<!DOCTYPE html>
<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
<!--[if gt IE 8]><!-->
<html class="no-js" lang="en">
<!--<![endif]-->
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>DbConnector - The .NET Core ORM Cookbook</title>
    <link rel="shortcut icon" href="favicon.ico">
    <link rel="stylesheet" href="css/theme.css" type="text/css" />
    <link rel="stylesheet" href="css/theme_colors.css" type="text/css" />
    <link rel="stylesheet" href="css/styles/vs.css">
    <link rel="stylesheet" href="css/font-awesome.4.5.0.min.css">
</head>
<body role="document">
    <div class="grid-for-nav">
        <nav data-toggle="nav-shift" class="nav-side stickynav">
            <div class="side-nav-search">
                <a href="index.htm"><i class="fa fa-home"></i> The .NET Core ORM Cookbook</a>
                <div role="search">
                    <form id="search-form" class="form" action="Docnet_search.htm" method="get">
                        <input type="text" name="q" placeholder="Search docs" />
                    </form>
                </div>
            </div>
            <div class="menu menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation">
<ul>
<li class="tocentry"><a href="index.htm">Home</a>
</li>

<li class="tocentry">
<ul>
<li><span class="navigationgroup"><i class="fa fa-caret-down"></i> <a href="ORMs.htm">ORMs</a></span></li>
<li class="tocentry"><a href="ADO.htm">ADO.NET</a>
</li>
<li class="tocentry"><a href="Chain.htm">Chain</a>
</li>
<li class="tocentry"><a href="Dapper.htm">Dapper</a>
</li>
<li class="tocentry current"><a class="current" href="DbConnector.htm">DbConnector</a>
<ul class="currentrelative">
<li class="tocentry"><a href="#supported-databases">Supported Databases</a></li>

<li class="tocentry"><a href="#libraries">Libraries</a></li>

<li class="tocentry"><a href="#setup">Setup</a></li>

<li class="tocentry"><a href="#documentation-and-tutorials">Documentation and Tutorials</a></li>

<li class="tocentry"><a href="#bug-reporting">Bug Reporting</a></li>

<li class="tocentry"><a href="#licensing">Licensing</a></li>



</ul>
<li class="tocentry"><a href="EF6.htm">Entity Framework 6</a>
</li>
<li class="tocentry"><a href="EFCore.htm">Entity Framework Core</a>
</li>
<li class="tocentry"><a href="LinqToDB.htm">LINQ to DB</a>
</li>
<li class="tocentry"><a href="LLBLGenPro.htm">LLBLGen Pro</a>
</li>
<li class="tocentry"><a href="NHibernate.htm">NHibernate</a>
</li>
<li class="tocentry"><a href="RepoDb.htm">RepoDb</a>
</li>
<li class="tocentry"><a href="ServiceStack.htm">ServiceStack</a>
</li>

</ul>
</li>
<li class="tocentry"><a href="FAQ.htm">FAQ</a>
</li>
<li class="tocentry">
<span class="navigationgroup"><i class="fa fa-caret-right"></i> <a href="StandardCRUDscenarios.htm">Standard CRUD scenarios</a></span>
</li>
<li class="tocentry">
<span class="navigationgroup"><i class="fa fa-caret-right"></i> <a href="Fetchingdatascenarios.htm">Fetching data scenarios</a></span>
</li>
<li class="tocentry">
<span class="navigationgroup"><i class="fa fa-caret-right"></i> <a href="Advancedscenarios.htm">Advanced scenarios</a></span>
</li>
<li class="tocentry">
<span class="navigationgroup"><i class="fa fa-caret-right"></i> <a href="Sortingscenarios.htm">Sorting scenarios</a></span>
</li>
<li class="tocentry">
<span class="navigationgroup"><i class="fa fa-caret-right"></i> <a href="Storedprocedurescenarios.htm">Stored procedure scenarios</a></span>
</li>
<li class="tocentry">
<span class="navigationgroup"><i class="fa fa-caret-right"></i> <a href="Auditingandhistoryscenarios.htm">Auditing and history scenarios</a></span>
</li>
<li class="tocentry">
<span class="navigationgroup"><i class="fa fa-caret-right"></i> <a href="Multi-Tenancyscenarios.htm">Multi-Tenancy scenarios</a></span>
</li>
<li class="tocentry">
<span class="navigationgroup"><i class="fa fa-caret-right"></i> <a href="UnknownDatabasescenarios.htm">Unknown Database scenarios</a></span>
</li>
</ul>
				<div class="toc-footer">
					<span class="text-small">
						<hr/>
						<a href="https://github.com/FransBouma/DocNet" target="_blank">Made with <i class="fa fa-github"></i> DocNet</a>
					</span>
				</div>	
			</div>
            &nbsp;
        </nav>
        <section data-toggle="nav-shift" class="nav-content-wrap">
            <nav class="nav-top" role="navigation" aria-label="top navigation">
                <i data-toggle="nav-top" class="fa fa-bars"></i>
                <a href="index.htm">The .NET Core ORM Cookbook</a>
            </nav>
            <div class="nav-content">
                <div role="navigation" aria-label="breadcrumbs navigation">
                    <div class="breadcrumbs">
<ul><li><a href="index.htm">Home</a></li> / <li><a href="ORMs.htm">ORMs</a></li> / <li><a href="DbConnector.htm">DbConnector</a></li></ul>
					
                    </div>
                    <hr />
                </div>
                <div role="main">
                    <div class="section">
<h1 id="dbconnector">DbConnector<a class="headerlink" href="#dbconnector" title="Permalink to this headline"><i class="fa fa-link" aria-hidden="true"></i></a></h1>
<p>DbConnector is a performance-driven and ADO.NET data provider-agnostic ORM library for .NET developed for individuals who strive to deliver high-quality software solutions. Object-Relational Mapping (ORM) is a technique that lets you query and manipulate data from a database using an object-oriented paradigm. This highly efficient library helps with the task of projecting/mapping data from any database, with the support of any third party data provider, into .NET objects and is comparable to the use of raw ADO.NET data reader implementations. </p>
<h2 id="supported-databases">Supported Databases<a class="headerlink" href="#supported-databases" title="Permalink to this headline"><i class="fa fa-link" aria-hidden="true"></i></a></h2>
<p>DbConnector supports any database that offers an ADO.NET provider.</p>
<p>ADO.NET requires the writing of SQL, which is often database specific.</p>
<div class="alert alert-warning"><span class="alert-title"><i class="fa fa-warning"></i> Warning!</span><p>Unless otherwise indicated, all examples of SQL are for SQL Server.</p>
</div><h2 id="libraries">Libraries<a class="headerlink" href="#libraries" title="Permalink to this headline"><i class="fa fa-link" aria-hidden="true"></i></a></h2>
<ul>
<li><a href="ADO.htm#libraries">ADO.NET</a> Database Specific Provider </li>
<li><a href="https://www.nuget.org/packages/SavantBuffer.DbConnector" target="_blank">DbConnector</a></li>
</ul>
<h2 id="setup">Setup<a class="headerlink" href="#setup" title="Permalink to this headline"><i class="fa fa-link" aria-hidden="true"></i></a></h2>
<p>Once you've downloaded and/or included the package into your .NET project, you have to reference the DbConnector and your preferred ADO.NET data provider namespaces in your code:</p>
<pre><code>using DbConnector.Core;
using System.Data.SqlClient; //Using SqlClient in this example.
</code></pre>

<p>Now, we can create an instance of the DbConnector using the targeted DbConnection type: </p>
<pre><code>//Note: You can use any type of data provider adapter that implements a DbConnection.
//E.g. PostgreSQL, Oracle, MySql, SQL Server

//Example using SQL Server connection
DbConnector&lt;SqlConnection&gt; _dbConnector = new DbConnector&lt;SqlConnection&gt;(&quot;connection string goes here&quot;);
</code></pre>

<div class="alert alert-warning"><span class="alert-title"><i class="fa fa-warning"></i> Warning!</span><p>This is a setup example for the C# language.</p>
</div><h2 id="documentation-and-tutorials">Documentation and Tutorials<a class="headerlink" href="#documentation-and-tutorials" title="Permalink to this headline"><i class="fa fa-link" aria-hidden="true"></i></a></h2>
<ul>
<li><a href="https://github.com/SavantBuffer/DbConnector" target="_blank">Quick Start</a></li>
</ul>
<h2 id="bug-reporting">Bug Reporting<a class="headerlink" href="#bug-reporting" title="Permalink to this headline"><i class="fa fa-link" aria-hidden="true"></i></a></h2>
<p>Issues should be logged in the <a href="https://github.com/SavantBuffer/DbConnector/issues" target="_blank">SavantBuffer/DbConnector repository</a>.</p>
<h2 id="licensing">Licensing<a class="headerlink" href="#licensing" title="Permalink to this headline"><i class="fa fa-link" aria-hidden="true"></i></a></h2>
<p>DbConnector is offered under the <a href="http://www.apache.org/licenses/LICENSE-2.0" target="_blank">Apache License version 2</a>.</p>

                    </div>
                </div>
                <footer>
                    <hr />
                    <div role="contentinfo">
The ORM Cookbook. <a href='https://github.com/Grauenwolf/DotNet-ORM-Cookbook' target='_blank'>Visit us at GitHub</a>.
                    </div>
                </footer>
            </div>
        </section>
    </div>
    <script src="js/jquery-2.1.1.min.js"></script>
    <script src="js/modernizr-2.8.3.min.js"></script>
    <script src="js/highlight.pack.js"></script>
    <script src="js/theme.js"></script>

</body>
</html>
